//Figure 7: Program Capabilities
//Author  : Sriram Rajagopalan

//Capabilities
Table ProjectGroupCapabilities {
  Capability_Id integer [pk]
  Project_Group_Id integer
  Milestone_Id integer
  Priority_Id integer
  Status_Id integer
  Type_Id integer
  Note: 'Stores Program level Capabilities with associated milestones'
}

Table ProjectGroupCapabilityPriorities {
  Priority_Id integer [pk]
  Note: 'Program Template: Stores Priority info for Capabilities'
}

Table ProjectGroupCapabilityProjectRequirements {
  Capability_Id integer [pk]
  Requirement_Id integer [pk]
  Artifact_Link_Type_Id integer
  Note: 'Stores Program  Capability mapping to Product Requirements'
}

Table ProjectGroupCapabilityStatuses {
  Status_Id integer [pk]
  Note: 'Program Template: Stores Status info for Capabilities'
}

Table ProjectGroupCapabilityTypes {
  Type_Id integer [pk]
  Note: 'Program Template: Stores Type info for Capabilities'
}

//Programs
Table ProjectGroupMilestones {
  Project_Group_Id integer
  Project_Group_Milestone_Id integer [pk]
  Status_Id integer
  Type_Id integer
  Note: 'Stores Proram Level Milestones with Program Status and Type'
}

Table ProjectGroupMilestoneProjectReleases {
  Project_Group_Milestone_Id integer [pk]
  Release_Id integer
  Artifact_Link_Type_Id integer
  Note: 'Stores Program Milestones to Product Releases'
}

Table ProjectGroupMilestoneStatuses {
  Status_Id integer [pk]
  Note: 'Program Template: Stores Status info for Milestones'
}

Table ProjectGroupMilestoneTypes {
  Type_Id Integer [pk]
  Note: 'Program Template: Stores Type info for Milestones'
}

  Table ProjectGroups {
    Project_Group_Id integer [pk]
    Portfolio_Id integer
    Note: 'Stores Programs (aka Project Groups) to Projects Mapping '
  }

// Projects
  Table Projects {
  Project_Id integer [pk]
  Project_Template_id integer
  Project_Group_Id integer
  Note: 'Stores Product Information'
}

//Minimal Relationships
// Releases  
  Table Releases {
  Release_Id integer [pk]
  Project_Id integer
  Project_Group_Id integer
  Note: 'Stores Product level Release Details'
}
//Program Milestones
Ref: "ProjectGroupMilestones"."Project_Group_Id" - "ProjectGroups"."Project_Group_Id"
Ref: "ProjectGroupMilestoneProjectReleases"."Release_Id" - "Releases"."Release_Id" 
Ref: "ProjectGroupMilestones"."Status_Id" - "ProjectGroupMilestoneStatuses"."Status_Id"
Ref: "ProjectGroupMilestones"."Type_Id" - "ProjectGroupMilestoneTypes"."Type_Id" 


//Program Capabilities
Ref: "ProjectGroupCapabilities"."Capability_Id" - "ProjectGroupCapabilityProjectRequirements"."Capability_Id" 
Ref: "ProjectGroupCapabilities"."Priority_Id" - "ProjectGroupCapabilityPriorities"."Priority_Id" 
Ref: "ProjectGroupCapabilities"."Status_Id" - "ProjectGroupCapabilityStatuses"."Status_Id" 
Ref: "ProjectGroupCapabilities"."Type_Id" - "ProjectGroupCapabilityTypes"."Type_Id" 
Ref: "ProjectGroupCapabilities"."Project_Group_Id" - "ProjectGroups"."Project_Group_Id"
Ref: "ProjectGroupCapabilities"."Milestone_Id" - "ProjectGroupMilestones"."Project_Group_Milestone_Id"

//Project Mappings
Ref: "Projects"."Project_Id" - "Releases"."Project_Id"
Ref: "ProjectGroups"."Project_Group_Id" - "Projects"."Project_Group_Id"